Entity Relationships - Contact Log (CONTACTLOG)

 

Related Tables

Table Name	Table Description	Primary Keys	Usually Joins From	Join Type	Joins On	Details
CONTACTLOG	Contact Log	CONTACTLOGID				Stores details of various forms of contact between Maytas users, trainees, assessors and employers.
CONTACTLOGFILES	Contact Log Files	FILEID, CONTACTLOGID	CONTACTLOG	One to many	CONTACTLOGID	Lists files associated with each contact log item.
TRAINEE	Trainee Basic Details	TRAINEEID	CONTACTLOG	Many to one	TRAINEEID	Stores basic details about each trainee.
ASSESSOR	Assessor Details	ASSESSORID	CONTACTLOG	Many to one	ASSESSORID	Stores basic details about each assessor.
EMPLOYER	Employer Details	EMPLOYERID	CONTACTLOG	Many to one	EMPLOYERID	Stores basic details about each employer.
M32$_USERS	User Details	USERID	CONTACTLOG	Many to one	USERID	Stores basic details about each Maytas user.